#! /bin/bash
export LANG=zh_CN.UTF-8
HIVE_HOME=/usr/bin/hive


${HIVE_HOME} -S -e

"create database if not exists edu_dm;
use edu_dm;

drop table if exists datetime;
create table datetime(
create_date_time string,
month_time string,
year_time string
)



drop table if exists  hcx_dm_cus_cnt;

create table hcx_dm_cus_cnt(
    time_type string,
    create_date_time string,
    month_time string,
    year_time string,
    cus_area string,
    sub_name string,
    sch_name string,
    origin_channel string,
    department_name string,
    group_type string,
    cus_amt bigint
)"